{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Afstand","Oppervlakte","Volume zonder Liter","Volume met Liter"],"not_rendered":{"images":3,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Afstand","index":0,"n_rows":46,"n_cols":55,"rows_kept":46,"merged":[[45,37,45,52]]}
[{"$nulls":9},"Controle status",null,0]
[]
[{"$nulls":9},"rangnr","eh","fact","mcht",{"$nulls":34},1,{"$nulls":6},1]
[{"$nulls":9},1,"mm",1E-3,{"$f":"LOG(L4)","v":-3},{"$nulls":34},0,{"$nulls":6},0]
[{"$nulls":9},2,"cm",0.01,{"$f":"LOG(L5)","v":-2},{"$nulls":34},2,{"$nulls":6},2]
[{"$nulls":9},3,"dm",0.1,-1]
[{"$nulls":9},4,"m",1,0]
[{"$nulls":9},5,"km",1000,3]
[{"$nulls":9},6,"mm",1E-3,{"$f":"LOG(L9)","v":-3}]
[{"$nulls":9},7,"cm",0.01,-2]
[{"$nulls":9},8,"dm",0.1,-1]
[{"$nulls":9},9,"m",1,0]
[]
[]
[{"$nulls":37},"Omrekenen van afstandseenheden: mm, cm, dm, m en km"]
[{"$nulls":37},"Vul bij de machten van 10 alleen getallen tussen 9 en -9 in. Gebruik bij de decimale getallen de komma (0,0…) en niet de punt (0.00…)."]
["Random",{"$nulls":3},"Random vastgezet",{"$nulls":5},"rnd(get)","rnd(mcht)","rnd(eh1)","eh1","mcht(eh1)","rnd(eh2)","eh2","mcht(eh2)","ant(get)","ant(mcht)"]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":9},{"$f":"ROUND((-3.5+RAND()*7),0)","v":1},{"$f":"ROUND((0.5+RAND()*5),0)","v":4},{"$f":"C18+ROUND((0.5+RAND()*4),0)","v":5},1,3,5,8,null,"Opgave 1",{"$f":"E18","v":1},{"$f":"F18","v":3},{"$f":"G18","v":5},{"$f":"VLOOKUP(M18,$J$4:$K$8,2,FALSE)","v":"km"},{"$f":"VLOOKUP(M18,$J$4:$M$8,4)","v":3},{"$f":"H18","v":8},{"$f":"VLOOKUP(P18,$J$4:$K$12,2,FALSE)","v":"dm"},{"$f":"VLOOKUP(P18,$J$4:$M$12,4,FALSE)","v":-1},{"$f":"K18","v":1},{"$f":"L18+O18-R18","v":7},null,{"$f":"K18","v":1},"·10^",{"$f":"L18","v":3},{"$f":"N18","v":"km"},"=",{"$f":"S18","v":1},"·10^",{"$f":"T18","v":7},{"$f":"Q18","v":"dm"},null,{"$f":"K18*10^L18","v":1000},{"$f":"N18","v":"km"},"=",{"$f":"S18*10^T18","v":10000000},{"$f":"Q18","v":"dm"},null,"Opgave 1",{"$f":"K18","v":1},"·10",{"$f":"L18","v":3},{"$f":"N18","v":"km"},"=",{"$f":"S18","v":1},"·10",null,{"$f":"Q18","v":"dm"},{"$f":"IF($L$1=1,1,IF(AT18=T18,2,0))","v":0},null,{"$f":"K18*10^L18","v":1000},{"$f":"N18","v":"km"},"=",null,{"$f":"Q18","v":"dm"},{"$f":"IF($L$1=1,1,IF(BA18=AI18,2,0))","v":0}]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":5},{"$f":"ROUND((-3.5+RAND()*7),0)","v":-3},{"$f":"ROUND((0.5+RAND()*5),0)","v":5},{"$f":"C19+ROUND((0.5+RAND()*4),0)","v":6},3,-3,4,8,null,"Opgave 2",{"$f":"E19","v":3},{"$f":"F19","v":-3},{"$f":"G19","v":4},{"$f":"VLOOKUP(M19,$J$4:$K$8,2,FALSE)","v":"m"},{"$f":"VLOOKUP(M19,$J$4:$M$8,4)","v":0},{"$f":"H19","v":8},{"$f":"VLOOKUP(P19,$J$4:$K$12,2,FALSE)","v":"dm"},{"$f":"VLOOKUP(P19,$J$4:$M$12,4,FALSE)","v":-1},{"$f":"K19","v":3},{"$f":"L19+O19-R19","v":-2},null,{"$f":"K19","v":3},"·10^",{"$f":"L19","v":-3},{"$f":"N19","v":"m"},"=",{"$f":"S19","v":3},"·10^",{"$f":"T19","v":-2},{"$f":"Q19","v":"dm"},null,{"$f":"K19*10^L19","v":0.003},{"$f":"N19","v":"m"},"=",{"$f":"S19*10^T19","v":0.03},{"$f":"Q19","v":"dm"},null,"Opgave 2",{"$f":"K19","v":3},"·10",{"$f":"L19","v":-3},{"$f":"N19","v":"m"},"=",{"$f":"S19","v":3},"·10",null,{"$f":"Q19","v":"dm"},{"$f":"IF($L$1=1,1,IF(AT19=T19,2,0))","v":0},null,{"$f":"K19*10^L19","v":0.003},{"$f":"N19","v":"m"},"=",null,{"$f":"Q19","v":"dm"},{"$f":"IF($L$1=1,1,IF(BA19=AI19,2,0))","v":0}]
[2,-1,1,4,6,-3,4,8,null,"Opgave 3",6,-3,4,"m",0,8,"dm",-1,6,-2,null,6,"·10^",-3,"m","=",6,"·10^",-2,"dm",null,0.006,"m","=",0.06,"dm",null,"Opgave 3",6,"·10",-3,"m","=",6,"·10",null,"dm",0,null,0.006,"m","=",null,"dm",0]
[2,-1,4,6,3,0,1,5,null,"Opgave 4",3,0,1,"mm",-3,5,"km",3,3,-6,null,3,"·10^",0,"mm","=",3,"·10^",-6,"km",null,3,"mm","=",3e-06,"km",null,"Opgave 4",3,"·10",0,"mm","=",3,"·10",null,"km",0,null,3,"mm","=",null,"km",0]
[1,-3,3,4,2,0,1,3,null,"Opgave 5",2,0,1,"mm",-3,3,"dm",-1,2,-2,null,2,"·10^",0,"mm","=",2,"·10^",-2,"dm",null,2,"mm","=",0.02,"dm",null,"Opgave 5",2,"·10",0,"mm","=",2,"·10",null,"dm",0,null,2,"mm","=",null,"dm",0]
[8,0,3,5,8,2,2,6,null,"Opgave 6",8,2,2,"cm",-2,6,"mm",-3,8,3,null,8,"·10^",2,"cm","=",8,"·10^",3,"mm",null,800,"cm","=",8000,"mm",null,"Opgave 6",8,"·10",2,"cm","=",8,"·10",null,"mm",0,null,800,"cm","=",null,"mm",0]
[3,0,3,7,1,3,1,2,null,"Opgave 7",1,3,1,"mm",-3,2,"cm",-2,1,2,null,1,"·10^",3,"mm","=",1,"·10^",2,"cm",null,1000,"mm","=",100,"cm",null,"Opgave 7",1,"·10",3,"mm","=",1,"·10",null,"cm",0,null,1000,"mm","=",null,"cm",0]
[2,3,5,7,8,1,2,3,null,"Opgave 8",8,1,2,"cm",-2,3,"dm",-1,8,0,null,8,"·10^",1,"cm","=",8,"·10^",0,"dm",null,80,"cm","=",8,"dm",null,"Opgave 8",8,"·10",1,"cm","=",8,"·10",null,"dm",2,null,80,"cm","=",null,"dm",0]
[1,3,4,6,6,2,1,4,null,"Opgave 9",6,2,1,"mm",-3,4,"m",0,6,-1,null,6,"·10^",2,"mm","=",6,"·10^",-1,"m",null,600,"mm","=",0.6000000000000001,"m",null,"Opgave 9",6,"·10",2,"mm","=",6,"·10",null,"m",0,null,600,"mm","=",null,"m",0]
[3,1,5,8,2,-2,2,4,null,"Opgave 10",2,-2,2,"cm",-2,4,"m",0,2,-4,null,2,"·10^",-2,"cm","=",2,"·10^",-4,"m",null,0.02,"cm","=",0.0002,"m",null,"Opgave 10",2,"·10",-2,"cm","=",2,"·10",null,"m",0,null,0.02,"cm","=",null,"m",0]
[]
[{"$nulls":37},"Aantal goed:",{"$nulls":9},{"$f":"COUNTIF(AV18:AV27,2)","v":1},{"$nulls":6},{"$f":"COUNTIF(BC18:BC27,2)","v":0}]
[]
[]
[]
[{"$nulls":39},"Druk op de knop om jouw antwoorden te controleren"]
[]
[]
[]
[]
[]
[{"$nulls":39},"Druk op de knop voor 10 nieuwe opgaven"]
[]
[]
[]
[{"$nulls":37},"Heb je vragen of denk je dat er iets niet klopt, maak dan een schermafdruk (Alt-PrtScr),"]
[{"$nulls":37},"plak de schermafdruk in een mailtje (Ctrl-v) en stuur het mailtje naar jouw vakdocent."]
[{"$nulls":37},"Gemaakt door: Frank van Doremalen "]
[{"$nulls":37},"Dit werk valt onder een Creative Commons Naamsvermelding-NietCommercieel-GelijkDelen 4.0 Internationaal-licentie."]

{"sheet":"Oppervlakte","index":1,"n_rows":44,"n_cols":55,"rows_kept":44,"merged":[[43,37,43,52]]}
[{"$nulls":9},"Controle status",null,0]
[]
[{"$nulls":9},"rangnr","eh","fact","mcht",{"$nulls":34},1,{"$nulls":6},1]
[{"$nulls":9},1,"mm²",1e-06,{"$f":"LOG(L4)","v":-6},{"$nulls":34},0,{"$nulls":6},0]
[{"$nulls":9},2,"cm²",1E-4,{"$f":"LOG(L5)","v":-4},{"$nulls":34},2,{"$nulls":6},2]
[{"$nulls":9},3,"dm²",0.01,-2]
[{"$nulls":9},4,"m²",1,0]
[{"$nulls":9},5,"mm²",1e-06,-6]
[{"$nulls":9},6,"cm²",1E-4,{"$f":"LOG(L9)","v":-4}]
[{"$nulls":9},7,"dm²",0.01,-2]
[]
[]
[{"$nulls":37},"Omrekenen van oppervlakte eenheden: mm2, cm2, dm2 en m2"]
[{"$nulls":37},"Vul bij de machten van 10 alleen getallen tussen 9 en -9 in. Gebruik bij de decimale getallen de komma (0,0…) en niet de punt (0.00…)."]
["Random",{"$nulls":3},"Random vastgezet",{"$nulls":5},"rnd(get)","rnd(mcht)","rnd(eh1)","eh1","mcht(eh1)","rnd(eh2)","eh2","mcht(eh2)","ant(get)","ant(mcht)"]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":8},{"$f":"ROUND((-3.5+RAND()*7),0)","v":-3},{"$f":"ROUND((0.5+RAND()*4),0)","v":2},{"$f":"C16+ROUND((0.5+RAND()*3),0)","v":4},5,-2,3,5,null,"Opgave 1",{"$f":"E16","v":5},{"$f":"F16","v":-2},{"$f":"G16","v":3},{"$f":"VLOOKUP(M16,$J$4:$K$8,2,FALSE)","v":"dm²"},{"$f":"VLOOKUP(M16,$J$4:$M$8,4)","v":-2},{"$f":"H16","v":5},{"$f":"VLOOKUP(P16,$J$4:$K$10,2,FALSE)","v":"mm²"},{"$f":"VLOOKUP(P16,$J$4:$M$10,4,FALSE)","v":-6},{"$f":"K16","v":5},{"$f":"L16+O16-R16","v":2},null,{"$f":"K16","v":5},"·10^",{"$f":"L16","v":-2},{"$f":"N16","v":"dm²"},"=",{"$f":"S16","v":5},"·10^",{"$f":"T16","v":2},{"$f":"Q16","v":"mm²"},null,{"$f":"K16*10^L16","v":0.05},{"$f":"N16","v":"dm²"},"=",{"$f":"S16*10^T16","v":500},{"$f":"Q16","v":"mm²"},null,"Opgave 1",{"$f":"K16","v":5},"·10",{"$f":"L16","v":-2},{"$f":"N16","v":"dm²"},"=",{"$f":"S16","v":5},"·10",null,{"$f":"Q16","v":"mm²"},{"$f":"IF($L$1=1,1,IF(AT16=T16,2,0))","v":0},null,{"$f":"K16*10^L16","v":0.05},{"$f":"N16","v":"dm²"},"=",null,{"$f":"Q16","v":"mm²"},{"$f":"IF($L$1=1,1,IF(BA16=AI16,2,0))","v":0}]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":4},{"$f":"ROUND((-3.5+RAND()*7),0)","v":0},{"$f":"ROUND((0.5+RAND()*4),0)","v":2},{"$f":"C17+ROUND((0.5+RAND()*3),0)","v":5},2,2,2,4,null,"Opgave 2",{"$f":"E17","v":2},2,2,{"$f":"VLOOKUP(M17,$J$4:$K$8,2,FALSE)","v":"cm²"},{"$f":"VLOOKUP(M17,$J$4:$M$8,4)","v":-4},{"$f":"H17","v":4},"m²",0,{"$f":"K17","v":2},{"$f":"L17+O17-R17","v":-2},null,{"$f":"K17","v":2},"·10^",{"$f":"L17","v":2},{"$f":"N17","v":"cm²"},"=",{"$f":"S17","v":2},"·10^",{"$f":"T17","v":-2},{"$f":"Q17","v":"m²"},null,{"$f":"K17*10^L17","v":200},{"$f":"N17","v":"cm²"},"=",{"$f":"S17*10^T17","v":0.02},{"$f":"Q17","v":"m²"},null,"Opgave 2",{"$f":"K17","v":2},"·10",{"$f":"L17","v":2},{"$f":"N17","v":"cm²"},"=",{"$f":"S17","v":2},"·10",null,{"$f":"Q17","v":"m²"},{"$f":"IF($L$1=1,1,IF(AT17=T17,2,0))","v":0},null,{"$f":"K17*10^L17","v":200},{"$f":"N17","v":"cm²"},"=",null,{"$f":"Q17","v":"m²"},{"$f":"IF($L$1=1,1,IF(BA17=AI17,2,0))","v":0}]
[4,1,4,7,8,0,2,4,null,"Opgave 3",8,0,2,"cm²",-4,4,"m²",0,8,-4,null,8,"·10^",0,"cm²","=",8,"·10^",-4,"m²",null,8,"cm²","=",0.0008,"m²",null,"Opgave 3",8,"·10",0,"cm²","=",8,"·10",null,"m²",0,null,8,"cm²","=",null,"m²",0]
[2,2,2,4,4,3,2,3,null,"Opgave 4",4,3,2,"cm²",-4,3,"dm²",-2,4,1,null,4,"·10^",3,"cm²","=",4,"·10^",1,"dm²",null,4000,"cm²","=",40,"dm²",null,"Opgave 4",4,"·10",3,"cm²","=",4,"·10",null,"dm²",0,null,4000,"cm²","=",null,"dm²",0]
[2,1,4,6,3,3,2,3,null,"Opgave 5",3,3,2,"cm²",-4,3,"dm²",-2,3,1,null,3,"·10^",3,"cm²","=",3,"·10^",1,"dm²",null,3000,"cm²","=",30,"dm²",null,"Opgave 5",3,"·10",3,"cm²","=",3,"·10",null,"dm²",0,null,3000,"cm²","=",null,"dm²",0]
[6,-2,4,5,8,-2,3,5,null,"Opgave 6",8,-2,3,"dm²",-2,5,"mm²",-6,8,2,null,8,"·10^",-2,"dm²","=",8,"·10^",2,"mm²",null,0.08,"dm²","=",800,"mm²",null,"Opgave 6",8,"·10",-2,"dm²","=",8,"·10",null,"mm²",0,null,0.08,"dm²","=",null,"mm²",0]
[2,2,1,3,3,1,4,7,null,"Opgave 7",3,1,4,"m²",0,7,"dm²",-2,3,3,null,3,"·10^",1,"m²","=",3,"·10^",3,"dm²",null,30,"m²","=",3000,"dm²",null,"Opgave 7",3,"·10",1,"m²","=",3,"·10",null,"dm²",0,null,30,"m²","=",null,"dm²",0]
[9,-3,4,6,7,1,4,5,null,"Opgave 8",7,1,4,"m²",0,5,"mm²",-6,7,7,null,7,"·10^",1,"m²","=",7,"·10^",7,"mm²",null,70,"m²","=",70000000,"mm²",null,"Opgave 8",7,"·10",1,"m²","=",7,"·10",null,"mm²",0,null,70,"m²","=",null,"mm²",0]
[5,-3,2,4,1,2,2,3,null,"Opgave 9",1,2,2,"cm²",-4,3,"dm²",-2,1,0,null,1,"·10^",2,"cm²","=",1,"·10^",0,"dm²",null,100,"cm²","=",1,"dm²",null,"Opgave 9",1,"·10",2,"cm²","=",1,"·10",null,"dm²",2,null,100,"cm²","=",null,"dm²",0]
[4,1,2,5,6,1,1,3,null,"Opgave 10",6,1,1,"mm²",-6,3,"dm²",-2,6,-3,null,6,"·10^",1,"mm²","=",6,"·10^",-3,"dm²",null,60,"mm²","=",0.006,"dm²",null,"Opgave 10",6,"·10",1,"mm²","=",6,"·10",null,"dm²",0,null,60,"mm²","=",null,"dm²",0]
[]
[{"$nulls":37},"Aantal goed:",{"$nulls":9},{"$f":"COUNTIF(AV16:AV25,2)","v":1},{"$nulls":6},{"$f":"COUNTIF(BC16:BC25,2)","v":0}]
[]
[]
[]
[{"$nulls":39},"Druk op de knop om jouw antwoorden te controleren"]
[]
[]
[]
[]
[]
[{"$nulls":39},"Druk op de knop voor 10 nieuwe opgaven"]
[]
[]
[]
[{"$nulls":37},"Heb je vragen of denk je dat er iets niet klopt, maak dan een schermafdruk (Alt-PrtScr),"]
[{"$nulls":37},"plak de schermafdruk in een mailtje (Ctrl-v) en stuur het mailtje naar jouw vakdocent."]
[{"$nulls":37},"Gemaakt door: Frank van Doremalen "]
[{"$nulls":37},"Dit werk valt onder een Creative Commons Naamsvermelding-NietCommercieel-GelijkDelen 4.0 Internationaal-licentie."]

{"sheet":"Volume zonder Liter","index":2,"n_rows":44,"n_cols":53,"rows_kept":44,"merged":[[43,37,43,52]]}
[{"$nulls":9},"Controle status",null,0]
[]
[{"$nulls":9},"rangnr","eh","fact","mcht",{"$nulls":32},1,{"$nulls":6},1]
[{"$nulls":9},1,"mm³",1e-09,{"$f":"LOG(L4)","v":-9},{"$nulls":32},0,{"$nulls":6},0]
[{"$nulls":9},2,"cm³",1e-06,{"$f":"LOG(L5)","v":-6},{"$nulls":32},2,{"$nulls":6},2]
[{"$nulls":9},3,"dm³",1E-3,-3]
[{"$nulls":9},4,"m³",1,0]
[{"$nulls":9},5,"mm³",1e-09,-9]
[{"$nulls":9},6,"cm³",1e-06,{"$f":"LOG(L9)","v":-6}]
[{"$nulls":9},7,"dm³",1E-3,-3]
[]
[]
[{"$nulls":37},"Omrekenen van oppervlakte eenheden: mm2, cm2, dm2 en m2"]
[{"$nulls":37},"Vul bij de machten van 10 alleen getallen tussen 9 en -9 in. Gebruik bij de decimale getallen de komma (0,0…) en niet de punt (0.00…)."]
["Random",{"$nulls":3},"Random vastgezet",{"$nulls":5},"rnd(get)","rnd(mcht)","rnd(eh1)","eh1","mcht(eh1)","rnd(eh2)","eh2","mcht(eh2)","ant(get)","ant(mcht)"]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":6},0,{"$f":"ROUND((0.5+RAND()*4),0)","v":1},{"$f":"C16+ROUND((0.5+RAND()*3),0)","v":4},9,0,4,7,null,"Opgave 1",{"$f":"E16","v":9},{"$f":"F16","v":0},{"$f":"G16","v":4},{"$f":"VLOOKUP(M16,$J$4:$K$8,2,FALSE)","v":"m³"},{"$f":"VLOOKUP(M16,$J$4:$M$8,4)","v":0},{"$f":"H16","v":7},{"$f":"VLOOKUP(P16,$J$4:$K$10,2,FALSE)","v":"dm³"},{"$f":"VLOOKUP(P16,$J$4:$M$10,4,FALSE)","v":-3},{"$f":"K16","v":9},{"$f":"L16+O16-R16","v":3},null,{"$f":"K16","v":9},"·10^",{"$f":"L16","v":0},{"$f":"N16","v":"m³"},"=",{"$f":"S16","v":9},"·10^",{"$f":"T16","v":3},{"$f":"Q16","v":"dm³"},null,{"$f":"K16*10^L16","v":9},{"$f":"N16","v":"m³"},"=",{"$f":"S16*10^T16","v":9000},{"$f":"Q16","v":"dm³"},null,"Opgave 1",{"$f":"K16","v":9},{"$f":"N16","v":"m³"},"=",{"$f":"S16","v":9},"·10",null,{"$f":"Q16","v":"dm³"},{"$f":"IF($L$1=1,1,IF(AR16=T16,2,0))","v":0},null,{"$f":"K16*10^L16","v":9},{"$f":"N16","v":"m³"},"=",null,{"$f":"Q16","v":"dm³"},{"$f":"IF($L$1=1,1,IF(AY16=AI16,2,0))","v":0}]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":6},0,{"$f":"ROUND((0.5+RAND()*4),0)","v":4},{"$f":"C17+ROUND((0.5+RAND()*3),0)","v":7},5,0,4,6,null,"Opgave 2",{"$f":"E17","v":5},0,4,{"$f":"VLOOKUP(M17,$J$4:$K$8,2,FALSE)","v":"m³"},{"$f":"VLOOKUP(M17,$J$4:$M$8,4)","v":0},{"$f":"H17","v":6},"cm³",-6,{"$f":"K17","v":5},{"$f":"L17+O17-R17","v":6},null,{"$f":"K17","v":5},"·10^",{"$f":"L17","v":0},{"$f":"N17","v":"m³"},"=",{"$f":"S17","v":5},"·10^",{"$f":"T17","v":6},{"$f":"Q17","v":"cm³"},null,{"$f":"K17*10^L17","v":5},{"$f":"N17","v":"m³"},"=",{"$f":"S17*10^T17","v":5000000},{"$f":"Q17","v":"cm³"},null,"Opgave 2",{"$f":"K17","v":5},"m³","=",5,"·10",null,"cm³",{"$f":"IF($L$1=1,1,IF(AR17=T17,2,0))","v":0},null,5,"m³","=",null,"cm³",{"$f":"IF($L$1=1,1,IF(AY17=AI17,2,0))","v":0}]
[4,0,3,6,1,0,2,5,null,"Opgave 3",1,0,2,"cm³",-6,5,"mm³",-9,1,3,null,1,"·10^",0,"cm³","=",1,"·10^",3,"mm³",null,1,"cm³","=",1000,"mm³",null,"Opgave 3",1,"cm³","=",1,"·10",null,"mm³",0,null,1,"cm³","=",null,"mm³",0]
[5,0,2,3,9,0,1,4,null,"Opgave 4",9,0,1,"mm³",-9,4,"m³",0,9,-9,null,9,"·10^",0,"mm³","=",9,"·10^",-9,"m³",null,9,"mm³","=",9.0000000000000012E-9,"m³",null,"Opgave 4",9,"mm³","=",9,"·10",null,"m³",0,null,9,"mm³","=",null,"m³",0]
[1,0,4,5,5,0,1,4,null,"Opgave 5",5,0,1,"mm³",-9,4,"m³",0,5,-9,null,5,"·10^",0,"mm³","=",5,"·10^",-9,"m³",null,5,"mm³","=",5e-09,"m³",null,"Opgave 5",5,"mm³","=",5,"·10",null,"m³",0,null,5,"mm³","=",null,"m³",0]
[1,0,4,6,6,0,2,4,null,"Opgave 6",6,0,2,"cm³",-6,4,"m³",0,6,-6,null,6,"·10^",0,"cm³","=",6,"·10^",-6,"m³",null,6,"cm³","=",6e-06,"m³",null,"Opgave 6",6,"cm³","=",6,"·10",null,"m³",0,null,6,"cm³","=",null,"m³",0]
[9,0,2,3,3,0,3,4,null,"Opgave 7",3,0,3,"dm³",-3,4,"m³",0,3,-3,null,3,"·10^",0,"dm³","=",3,"·10^",-3,"m³",null,3,"dm³","=",0.003,"m³",null,"Opgave 7",3,"dm³","=",3,"·10",null,"m³",0,null,3,"dm³","=",null,"m³",0]
[6,0,4,5,1,0,4,6,null,"Opgave 8",1,0,4,"m³",0,6,"cm³",-6,1,6,null,1,"·10^",0,"m³","=",1,"·10^",6,"cm³",null,1,"m³","=",1000000,"cm³",null,"Opgave 8",1,"m³","=",1,"·10",null,"cm³",0,null,1,"m³","=",null,"cm³",0]
[7,0,1,2,3,0,1,2,null,"Opgave 9",3,0,1,"mm³",-9,2,"cm³",-6,3,-3,null,3,"·10^",0,"mm³","=",3,"·10^",-3,"cm³",null,3,"mm³","=",0.003,"cm³",null,"Opgave 9",3,"mm³","=",3,"·10",null,"cm³",0,null,3,"mm³","=",null,"cm³",0]
[9,0,3,4,6,0,4,5,null,"Opgave 10",6,0,4,"m³",0,5,"mm³",-9,6,9,null,6,"·10^",0,"m³","=",6,"·10^",9,"mm³",null,6,"m³","=",6000000000,"mm³",null,"Opgave 10",6,"m³","=",6,"·10",null,"mm³",0,null,6,"m³","=",null,"mm³",0]
[]
[{"$nulls":37},"Aantal goed:",{"$nulls":7},{"$f":"COUNTIF(AT16:AT25,2)","v":0},{"$nulls":6},{"$f":"COUNTIF(BA16:BA25,2)","v":0}]
[]
[]
[]
[{"$nulls":39},"Druk op de knop om jouw antwoorden te controleren"]
[]
[]
[]
[]
[]
[{"$nulls":39},"Druk op de knop voor 10 nieuwe opgaven"]
[]
[]
[]
[{"$nulls":37},"Heb je vragen of denk je dat er iets niet klopt, maak dan een schermafdruk (Alt-PrtScr),"]
[{"$nulls":37},"plak de schermafdruk in een mailtje (Ctrl-v) en stuur het mailtje naar jouw vakdocent."]
[{"$nulls":37},"Gemaakt door: Frank van Doremalen "]
[{"$nulls":37},"Dit werk valt onder een Creative Commons Naamsvermelding-NietCommercieel-GelijkDelen 4.0 Internationaal-licentie."]

{"sheet":"Volume met Liter","index":3,"n_rows":52,"n_cols":53,"rows_kept":52,"merged":[[51,37,51,50]]}
[{"$nulls":9},"Controle status",null,0]
[]
[{"$nulls":9},"rangnr","eh","fact","mcht",{"$nulls":32},1,{"$nulls":6},1]
[{"$nulls":9},1,"mm³",1e-09,{"$f":"LOG(L4)","v":-9},{"$nulls":32},0,{"$nulls":6},0]
[{"$nulls":9},2,"cm³",1e-06,{"$f":"LOG(L5)","v":-6},{"$nulls":32},2,{"$nulls":6},2]
[{"$nulls":9},3,"dm³",1E-3,-3]
[{"$nulls":9},4,"m³",1,0]
[{"$nulls":9},5,"mL",1e-06,-6]
[{"$nulls":9},6,"cL",1e-05,{"$f":"LOG(L9)","v":-5}]
[{"$nulls":9},7,"dL",1E-4,-4]
[{"$nulls":9},8,"L",1E-3,-3]
[{"$nulls":9},9,"mm³",1e-09,{"$f":"LOG(L12)","v":-9}]
[{"$nulls":9},10,"cm³",1e-06,-6]
[{"$nulls":9},11,"dm³",1E-3,-3]
[{"$nulls":9},12,"m³",1,0]
[{"$nulls":9},13,"mL",1e-06,-6]
[{"$nulls":9},14,"cL",1e-05,{"$f":"LOG(L17)","v":-5}]
[{"$nulls":9},15,"dL",1E-4,-4]
[]
[]
[{"$nulls":37},"Omrekenen van oppervlakte eenheden: mm2, cm2, dm2 en m2"]
[{"$nulls":37},"Vul bij de machten van 10 alleen getallen tussen 9 en -9 in. Gebruik bij de decimale getallen de komma (0,0…) en niet de punt (0.00…)."]
["Random",{"$nulls":3},"Random vastgezet",{"$nulls":5},"rnd(get)","rnd(mcht)","rnd(eh1)","eh1","mcht(eh1)","rnd(eh2)","eh2","mcht(eh2)","ant(get)","ant(mcht)"]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":5},0,{"$f":"ROUND((0.5+RAND()*8),0)","v":4},{"$f":"C24+ROUND((0.5+RAND()*7),0)","v":8},1,0,4,5,null,"Opgave 1",{"$f":"E24","v":1},{"$f":"F24","v":0},{"$f":"G24","v":4},{"$f":"VLOOKUP(M24,$J$4:$K$18,2,FALSE)","v":"m³"},{"$f":"VLOOKUP(M24,$J$4:$M$18,4)","v":0},{"$f":"H24","v":5},{"$f":"VLOOKUP(P24,$J$4:$K$18,2,FALSE)","v":"mL"},{"$f":"VLOOKUP(P24,$J$4:$M$18,4,FALSE)","v":-6},{"$f":"K24","v":1},{"$f":"L24+O24-R24","v":6},null,{"$f":"K24","v":1},"·10^",{"$f":"L24","v":0},{"$f":"N24","v":"m³"},"=",{"$f":"S24","v":1},"·10^",{"$f":"T24","v":6},{"$f":"Q24","v":"mL"},null,{"$f":"K24*10^L24","v":1},{"$f":"N24","v":"m³"},"=",{"$f":"S24*10^T24","v":1000000},{"$f":"Q24","v":"mL"},null,"Opgave 1",{"$f":"K24","v":1},{"$f":"N24","v":"m³"},"=",{"$f":"S24","v":1},"·10",null,{"$f":"Q24","v":"mL"},{"$f":"IF($L$1=1,1,IF(AR24=T24,2,0))","v":0},null,{"$f":"K24*10^L24","v":1},{"$f":"N24","v":"m³"},"=",null,{"$f":"Q24","v":"mL"},{"$f":"IF($L$1=1,1,IF(AY24=AI24,2,0))","v":0}]
[{"$f":"ROUND((0.5+RAND()*9),0)","v":8},0,{"$f":"ROUND((0.5+RAND()*8),0)","v":4},{"$f":"C25+ROUND((0.5+RAND()*7),0)","v":10},5,0,7,10,null,"Opgave 2",{"$f":"E25","v":5},{"$f":"F25","v":0},{"$f":"G25","v":7},{"$f":"VLOOKUP(M25,$J$4:$K$18,2,FALSE)","v":"dL"},{"$f":"VLOOKUP(M25,$J$4:$M$18,4)","v":-4},{"$f":"H25","v":10},{"$f":"VLOOKUP(P25,$J$4:$K$18,2,FALSE)","v":"cm³"},{"$f":"VLOOKUP(P25,$J$4:$M$18,4,FALSE)","v":-6},{"$f":"K25","v":5},{"$f":"L25+O25-R25","v":2},null,{"$f":"K25","v":5},"·10^",{"$f":"L25","v":0},{"$f":"N25","v":"dL"},"=",{"$f":"S25","v":5},"·10^",{"$f":"T25","v":2},{"$f":"Q25","v":"cm³"},null,{"$f":"K25*10^L25","v":5},{"$f":"N25","v":"dL"},"=",{"$f":"S25*10^T25","v":500},{"$f":"Q25","v":"cm³"},null,"Opgave 2",{"$f":"K25","v":5},"dL","=",5,"·10",null,"cm³",{"$f":"IF($L$1=1,1,IF(AR25=T25,2,0))","v":0},null,5,"dL","=",null,"cm³",{"$f":"IF($L$1=1,1,IF(AY25=AI25,2,0))","v":0}]
[5,0,6,9,1,0,8,11,null,"Opgave 3",1,0,8,"L",-3,11,"dm³",-3,1,0,null,1,"·10^",0,"L","=",1,"·10^",0,"dm³",null,1,"L","=",1,"dm³",null,"Opgave 3",1,"L","=",1,"·10",null,"dm³",2,null,1,"L","=",null,"dm³",0]
[4,0,5,7,8,0,4,6,null,"Opgave 4",8,0,4,"m³",0,6,"cL",-5,8,5,null,8,"·10^",0,"m³","=",8,"·10^",5,"cL",null,8,"m³","=",800000,"cL",null,"Opgave 4",8,"m³","=",8,"·10",null,"cL",0,null,8,"m³","=",null,"cL",0]
[8,0,2,3,5,0,6,11,null,"Opgave 5",5,0,6,"cL",-5,11,"dm³",-3,5,-2,null,5,"·10^",0,"cL","=",5,"·10^",-2,"dm³",null,5,"cL","=",0.05,"dm³",null,"Opgave 5",5,"cL","=",5,"·10",null,"dm³",0,null,5,"cL","=",null,"dm³",0]
[9,0,3,5,5,0,1,8,null,"Opgave 6",5,0,1,"mm³",-9,8,"L",-3,5,-6,null,5,"·10^",0,"mm³","=",5,"·10^",-6,"L",null,5,"mm³","=",4.9999999999999996E-6,"L",null,"Opgave 6",5,"mm³","=",5,"·10",null,"L",0,null,5,"mm³","=",null,"L",0]
[3,0,8,12,1,0,6,10,null,"Opgave 7",1,0,6,"cL",-5,10,"cm³",-6,1,1,null,1,"·10^",0,"cL","=",1,"·10^",1,"cm³",null,1,"cL","=",10,"cm³",null,"Opgave 7",1,"cL","=",1,"·10",null,"cm³",0,null,1,"cL","=",null,"cm³",0]
[8,0,1,2,1,0,8,11,null,"Opgave 8",1,0,8,"L",-3,11,"dm³",-3,1,0,null,1,"·10^",0,"L","=",1,"·10^",0,"dm³",null,1,"L","=",1,"dm³",null,"Opgave 8",1,"L","=",1,"·10",null,"dm³",2,null,1,"L","=",null,"dm³",0]
[4,0,1,8,2,0,1,6,null,"Opgave 9",2,0,1,"mm³",-9,6,"cL",-5,2,-4,null,2,"·10^",0,"mm³","=",2,"·10^",-4,"cL",null,2,"mm³","=",0.0002,"cL",null,"Opgave 9",2,"mm³","=",2,"·10",null,"cL",0,null,2,"mm³","=",null,"cL",0]
[7,0,1,3,5,0,3,6,null,"Opgave 10",5,0,3,"dm³",-3,6,"cL",-5,5,2,null,5,"·10^",0,"dm³","=",5,"·10^",2,"cL",null,5,"dm³","=",500,"cL",null,"Opgave 10",5,"dm³","=",5,"·10",null,"cL",0,null,5,"dm³","=",null,"cL",0]
[]
[{"$nulls":37},"Aantal goed:",{"$nulls":7},{"$f":"COUNTIF(AT24:AT33,2)","v":2},{"$nulls":6},{"$f":"COUNTIF(BA24:BA33,2)","v":0}]
[]
[]
[]
[{"$nulls":39},"Druk op de knop om jouw antwoorden te controleren"]
[]
[]
[]
[]
[]
[{"$nulls":39},"Druk op de knop voor 10 nieuwe opgaven"]
[]
[]
[]
[{"$nulls":37},"Heb je vragen of denk je dat er iets niet klopt, maak dan een schermafdruk (Alt-PrtScr),"]
[{"$nulls":37},"plak de schermafdruk in een mailtje (Ctrl-v) en stuur het mailtje naar jouw vakdocent."]
[{"$nulls":37},"Gemaakt door: Frank van Doremalen "]
[{"$nulls":37},"Dit werk valt onder een Creative Commons Naamsvermelding-NietCommercieel-GelijkDelen 4.0 Internationaal-licentie."]